| Key Name |
Key Type |
Keys |
| SyStudentNI_DSOSyStaffID_N_N_IDX |
Inversion Entry |
DsoStaffId |
| SyStudentNI_CPTEmployerID_N_N_IDX |
Inversion Entry |
CPTEmployerID |
| SyStudentNI_CountryOfLPR_N_N_IDX |
Inversion Entry |
LastPermanentResidenceCountry |
| SyStudentNI_CountryOfCitizenship_N_N_IDX |
Inversion Entry |
CitizenshipCountry |
| SyStudentNI_CountryOfBirth_N_N_IDX |
Inversion Entry |
BirthCountry |
| SyStudentNI_UserID_N_N_IDX |
Inversion Entry |
LastModifiedUserId |
| SyStudentNI_SyVisaCode_N_N_IDX |
Inversion Entry |
VisaCode |
| SyStudentNI_Position_N_N_IDX |
Inversion Entry |
Position |
| SyStudentNI_OPTEmployerID_N_N_IDX |
Inversion Entry |
OPTEmployerID |
| SyStudentNI_SyStudentID_U_C_IDX |
Alternate Key |
StudentId |
| SyStudentNI_AdEnrollID_N_N_IDX |
Inversion Entry |
StudentEnrollmentPeriodId |
| PK_SyStudentNI |
PrimaryKey |
SevisStudentId |
| Entity Name |
Type |
Cardinality |
Business Name |
VerbPhrase |
InversePhrase |
Foreign Keys |
Is Supertype |
| Employer |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
EmployerId |
NO |
| Staff |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StaffId |
NO |
| StudentEnrollmentPeriod |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentPeriodId |
NO |
| SevisCountry |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
BirthCountry |
NO |
| SevisCountry |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CitizenshipCountry |
NO |
| SevisCountry |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
LastPermanentResidenceCountry |
NO |
| Employer |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
CPTEmployerID |
NO |
| Staff |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
DsoStaffId |
NO |
| Employer |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
OPTEmployerID |
NO |
| SevisPosition |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
Position |
NO |
| Student |
Non-Identifying |
One To Zero or More |
|
|
|
StudentId |
NO |
| VisaType |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
VisaCode |
NO |
| Staff |
Non-Identifying |
One To Zero or More |
|
|
|
LastModifiedUserId |
NO |
| Employer |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
EmployerId |
NO |
| Student |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentId |
NO |
| StudentEnrollmentPeriod |
Non-Identifying |
Zero or One to Zero or More |
|
|
|
StudentEnrollmentPeriodId |
NO |
| Check Constraint Name |
CheckConstraint |
| Chk_SyStudentNI_UsIntlAgFund2 |
([UsIntlAg2] is not null or [UsIntlAgFund2] = 0) |
| Chk_SyStudentNI_EngProfRequired_EngProfMet |
([EngProfRequired] = 1 and [EngProfMet] = 0 or [EngProfRequired] = 1 and [EngProfMet] = 1 or [EngProfRequired] = 0 and [EngProfMet] = 0) |
| Chk_SyStudentNI_CPTEmploymentStartDate |
([CPTEmploymentStartDate] <= [CPTEmploymentEndDate]) |
| Chk_SyStudentNI_CPTApplicationDate |
([CPTApplicationDate] <= [CPTApprovalDate]) |
| Chk_SyStudentNI_ProgStartDate |
([ProgStartDate] <= [ProgEndDate]) |
| Chk_SyStudentNI_UsGovtAgFund2 |
([UsGovtAg2] is not null or [UsGovtAgFund2] = 0) |
| Chk_SyStudentNI_USGovtAgFund1 |
([UsGovtAg1] is not null or [UsGovtAgFund1] = 0) |
| Chk_SyStudentNI_AuthStartDate |
([AuthStartDate] <= [AuthEndDate]) |
| Chk_SyStudentNI_OPTEmploymentStartDate |
([OPTEmploymentStartDate] <= [OPTEmploymentEndDate]) |
| Chk_SyStudentNI_OPTApplicationDate |
([OPTApplicationDate] <= [OPTApprovalDate]) |
| Chk_SyStudentNI_USIntlAgFund1 |
([UsIntlAg1] is not null or [UsIntlAgFund1] = 0) |